create table hr_user_cv
(
    user_cv_uuid    nvarchar(64) not null
        constraint hr_user_cv_pk
            primary key nonclustered,
    fk_hr_user_uuid varchar(64)  not null,
    order_num       nvarchar(64),
    begin_at        datetime     not null,
    end_at          datetime     not null,
    company_name    nvarchar(64) not null,
    fk_sys_post_id  bigint       not null,
    remark          nvarchar(64)
)
go

exec sp_addextendedproperty 'MS_Description', '用户信息表-履历表', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv'
go

exec sp_addextendedproperty 'MS_Description', '用户（附表）UUID-外键', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN',
     'fk_hr_user_uuid'
go

exec sp_addextendedproperty 'MS_Description', '序号', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN', 'order_num'
go

exec sp_addextendedproperty 'MS_Description', '开始时间', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN', 'begin_at'
go

exec sp_addextendedproperty 'MS_Description', '结束时间', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN', 'end_at'
go

exec sp_addextendedproperty 'MS_Description', '单位名称', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN', 'company_name'
go

exec sp_addextendedproperty 'MS_Description', '职务（外键）', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN',
     'fk_sys_post_id'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 'hr_user_cv', 'COLUMN', 'remark'
go

